

/****** Object:  Trigger [dbo].[Tr_InsertIntoEvoUser]    Script Date: 06/09/2009 02:25:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE TRIGGER [dbo].[Tr_InsertIntoEvoUser] 
   ON  [dbo].[aspnet_Users] 
   AFTER INSERT
AS 
BEGIN

    -- Insert statements for trigger here
    INSERT INTO [EVOL_User]
           ([UserID]
           ,[Admin]
           ,[UserIDFromAspnet]
           ,[Login]
           ,[Password])
    select 1,1,UserId,UserName,'*******' from inserted
           

END


GO


